{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "lu353018580\n",
      "lxh4594\n",
      "pyue2008\n",
      "W1B2X3L4\n",
      "we111026\n",
      "WJ-well\n",
      "wu8878v\n",
      "qqqqqqqq910616\n",
      "wbx910616\n",
      "wxid_yxiw8quf97cl22\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Index: 7917 entries, 0 to 36\n",
      "Data columns (total 26 columns):\n",
      " #   Column      Non-Null Count  Dtype \n",
      "---  ------      --------------  ----- \n",
      " 0   用户ID        7917 non-null   object\n",
      " 1   交易单号        7917 non-null   object\n",
      " 2   大单号         3684 non-null   object\n",
      " 3   用户侧账号名称     7917 non-null   object\n",
      " 4   借贷类型        7917 non-null   object\n",
      " 5   交易业务类型      7917 non-null   object\n",
      " 6   交易用途类型      7917 non-null   object\n",
      " 7   交易时间        7917 non-null   object\n",
      " 8   交易金额(分)     7917 non-null   object\n",
      " 9   账户余额(分)     7917 non-null   object\n",
      " 10  用户银行卡号      1795 non-null   object\n",
      " 11  用户侧银行名称     1795 non-null   object\n",
      " 12  用户侧网银联单号    1795 non-null   object\n",
      " 13  网联/银联       1721 non-null   object\n",
      " 14  第三方账户名称     410 non-null    object\n",
      " 15  对手方ID       7863 non-null   object\n",
      " 16  对手侧账户名称     7865 non-null   object\n",
      " 17  对手方银行卡号     1607 non-null   object\n",
      " 18  对手侧银行名称     1635 non-null   object\n",
      " 19  对手侧网银联单号    2780 non-null   object\n",
      " 20  网联/银联.1     1575 non-null   object\n",
      " 21  第三方账户名称.1   59 non-null     object\n",
      " 22  对手方接收时间     2295 non-null   object\n",
      " 23  对手方接收金额(分)  2295 non-null   object\n",
      " 24  备注1         4068 non-null   object\n",
      " 25  备注2         988 non-null    object\n",
      "dtypes: object(26)\n",
      "memory usage: 1.6+ MB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "target_path = r\"F:\\工作任务\\2024-09-26统计卖淫案件的累计金额\\微信对应流水1(主要付款人累计金额，收款人累计金额).xlsx\"\n",
    "#df = pd.read_excel(target_path)\n",
    "sheet_names = pd.ExcelFile(target_path).sheet_names\n",
    "rs = pd.DataFrame()\n",
    "for sheet_name in sheet_names:\n",
    "    print(sheet_name)\n",
    "    df = pd.read_excel(target_path, sheet_name=sheet_name,dtype=str)\n",
    "    rs = pd.concat([rs,df])\n",
    "print(rs.info())\n",
    "rs.to_excel(\"微信交易流水信息数据处理.xlsx\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
